﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace AWA.VAT.DbAccess.Excel
{
    public abstract class ExcelBase
    {
        #region Fields
        protected string FileLocation { get; set; }

        #region Columns
        protected string AMVTitleCell = "G";
        protected string ArtistCell = "I";
        protected string SongCell = "K";
        protected string Source1Cell = "M";
        protected string Source2Cell = "O";
        protected string Source3Cell = "Q";
        protected string CommentsCell = "AW"; // may contain an http link
        protected string LinkCell = "AY";
        protected string StatusCell = "BA";
        protected string ContestCell = "C";
        protected string DisqualCell = "BI"; // Yes or No
        protected string DisqualReasonCell = "BK";

        protected string RealNameCell = "AC";
        protected string CreatorNameCell = "AE";
        protected string EmailCell = "AA";
        protected string StreetAddressCell = "AG";
        protected string CityCell = "AI";
        protected string StateCell = "AK";
        protected string ZIPCell = "AM";
        protected string CountryCell = "AO";
        protected string StudioCell = "AQ";
        protected string BirthdateCell = "AS";

        protected string EmailSentCell = "BL";
        protected string RespondedCell = "BM";
        protected string AttendingCell = "BN";
        protected string RespondRemarkCell = "BO";
        protected string CheckedInCell = "BP";

        protected string Award1Cell = "BQ";
        protected string Award2Cell = "BR";
        protected string AwardedCell = "BS";
        #endregion

        protected string _tabName = "awa2012_Entry_List_25-Sep-2012";

        protected int _firstRow = 5;
        protected int _lastRow = 216; // was 219 with three rows of NG Silver test data 
        #endregion
    }
}
